Insert Defaults Skip Columns Registry entry

Specify fields that should not have a default value assigned to them in New mode.

A default value displays in a field when a module is opened in New or Search mode. A default value is the most commonly used value in a field and is intended to save time and effort during data entry. The Insert Defaults Registry entry specifies a set of values to display by default in a module when the module enters New mode.

It might not be appropriate for some fields (System populated fields such as date fields, for example) to have a default value assigned to them. The purpose of Insert Defaults Skip Columns is to specify fields that should be excluded from a set of default fields, and thus never have a default value associated with them.

Note: The purpose of the Insert Defaults Skip Columns Registry entry is to stop users from specifying a default value for an excluded field when setting default values. An Administrator is always able to set any field as a default in Insert mode (excluding IRN), even if an Insert Defaults Skip Columns Registry explicitly excludes it. IRN is never stored as a default and it is not necessary to specify an Insert Defaults Skip Columns entry for IRN.

Usage

This Registry entry can be assigned to users and groups:

Key User User Group Group Group Group
Key 1 User User Group Group Group Group
Key 2 user user group group Default Default
Key 3 Table Table Table Table Table Table
Key 4 table Default table Default table Default
Key 5 Insert Defaults Skip Columns
Value column;column;...
User user Table table Insert Defaults Skip Columns column;column;...
User user Table Default Insert Defaults Skip Columns column;column;...
Group group Table table Insert Defaults Skip Columns column;column;...
Group group Table Default Insert Defaults Skip Columns column;column;...
Group Default Table table Insert Defaults Skip Columns column;column;...
Group Default Table Default Insert Defaults Skip Columns column;column;...

where:

column;column;...

is a semicolon separated list of column names.

Example

This entry could be used in order that fields set by the System do not have defaults assigned to them in New mode:

Key Setting
Key 1 Group
Key 2 Default
Key Table
Key 4 Default
Key 5 Insert Defaults Skip Columns
Value AdmInsertedBy;AdmDateInserted;AdmTimeInserted;AdmDateModified;AdmTimeModified; AdmModifiedBy;AdmPublishWebNoPassword;AdmPublishWebPassword